SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_GetCollNoByName]
    (
      @fdCollName VARCHAR(50)
    )
AS 
    SELECT  fdCollID
    FROM    dbo.FS_College
    WHERE   fdCollName = @fdCollName
GO
